Release 10.1A: OpenEdge Development:
Progress Dynamics Repository Reference

gsm_group_allocation table — gscsm

This table stores records of the groups to which a user belongs. This information is used for security purposes. You can also set up groups that belong to other groups. If the login company is specified, this indicates that security for the group only applies when logged in as the specified company.

Table 11–5 lists the table’s FLA, fields, and foreign keys.

Table 11–5: gsm_group_allocation table information 

Table FLA	Fields (data type)	Foreign keys
gsmga	group_allocation_obj (Decimal) group_user_obj (Decimal) user_obj (Decimal) login_company_obj (Decimal)	login_company_obj user_obj

Table 11–6 gives details of the table’s indexes.

Table 11–6: gsm_group_allocation index information 

Index name	Elements	Type
XPKgsm_group_allocation	group_allocation_obj	Primary Unique
XAK1gsm_group_allocation	group_user_obj user_obj login_company_obj	Unique
XIE1gsm_group_allocation	user_obj	Nonunique
XIE2gsm_group_allocation	login_company_obj	Nonunique